package com.ruoyi.customer.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.customer.domain.Remark;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Update;

/**
 * 备注信息Mapper接口
 *
 * @author suntf
 * @date 2023-07-29
 */
public interface RemarkMapper extends BaseMapper<Remark> {

    @Update("UPDATE t_customer_remak  SET `del_flag` = 1, update_by = #{updateBy}, update_time = now() WHERE (customer_id = #{customerId} AND `del_flag` = 0) ")
    void deleteRemark(@Param("customerId") String customerId, @Param("updateBy") String updateBy);
}
